To select a function for the main calculation via the settings pane, follow these steps:

1.Open the Constructor tab of the pivot table settings pane.

2.In the Values area, in the Calculations field, expand the drop-down list of functions corresponding to this field.

3.Select the desired function from the drop-down list.

To select a function for the main calculation via the context menu, follow these steps:

1.Select a cell or range of cells with calculated values in the pivot table.

2.Open the context menu by right-clicking, point to the Calculations option and select desired function.